Optional Parameters for All Dgn2Sdo File Types
IN_EXTENT=<xmin,ymin,xmax,ymax>: Specifies a spatial extent, used when scanning the input design file.
OUT_DIR=<outdir>: Overrides the default output directory where SQL Loader scripts are placed.
OUT_GEOM_COL=<geometry column name>: Geometry column name to use for generated SDO_GEOMETRY columns. Defaults to "OGC_GEOMETRY".
OUT_CS=<output SRID>: Output coordinate system (Oracle SRID) for the generated spatial layers. Defaults to null.
Example: OUT_CS=81989
Oracle SRIDs can be found in the table MDSYS.CS_SRS.
It looks like:
SQL> describe mdsys.cs_srs;
Name |
Null? |
Type |
---|---|---|
CS_NAME |
. |
VARCHAR2(80) |
SRID |
NOT NULL |
NUMBER(38) |
AUTH_SRID |
. |
NUMBER(38) |
AUTH_NAME |
. |
VARCHAR2(256) |
WKTEXT |
. |
VARCHAR2(2046) |
CS_BOUNDS |
. |
MDSYS.SDO_GEOMETRY |
Query the table using a select statement such as:
select CS_NAME, SRID from MDSYS.CS_SRS where CS_NAME like 'British%';
This will return all coordinate systems that start with British in the name.
OUT_GEOM_TOL=<geomtolerance>: The tolerance to set on generated SDO_GEOMETRY columns. Defaults to 0.000000050.
OUT_SPATIAL_INDEX=<TRUE|FALSE>: A flag indicating whether the generated SQL script for creating spatial tables should also contain a SQL statement to create a spatial index for the table. Default is TRUE.
OUT_INDEX_TYPE=<spatialindextype>: An override to the spatial index type. Only used if OUT_SPATIAL_INDEX is set to TRUE. If this argument is not specified, the index type is determined automatically from the input datastream.
Valid parameters are: POINT,LINE or CURVE,POLYGON, COLLECTION, MULTIPOINT, MULTILINE or MULTICURVE, MULTIPOLYGON
OUT_DIM=<2D|3D>: Specify the dimension of the generated spatial layer. Default = 2D.
OUT_XDIM=(min_x,max_x): Override the generated spatial layer limits for the X axis.
OUT_YDIM=(min_y,max_y): Override the generated spatial layer limits for the Y axis.
OUT_ZDIM=(min_z,max_z): Override the generated spatial layer limits for the Z axis.
OUT_PK_COL_NAME=<Primary Key name>: Override the generated name for the primary key column.
OUT_PK_START=<start value>: Override the default starting value for generated Primary Key values.
OUT_DELIM=<char>: Override the field delimiter to use in generated SQL*Loader .DAT files.
OUT_SCHEMA_ONLY=<true|false>: Specifies that table creation and indexing scripts be created, but does not generate any SQL*Loader scripts.
OUT_SCHEMA_FEATURES=<true|false> : Specifies that table creation and indexing scripts be created for all schema features regardless of whether or not instances exist in the input file(s).
IN_WP=<project_config_file>: Specifies a MicroStation project configuration file (.pcf) to use.
IN_WR=<workspace_root>: Specifies an alternate MicroStation workspace root directory to use.